using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using EM.Repository.utility;

namespace EM.Common
{
    public partial class support : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

            int PageId = 241;
            Authentication Rua = new Authentication();
            Rua.CheckRolePageAuthentication(PageId, Authentication.RedirectionURLTypes.TimeOutPage);

            DbHelper dsrv = new DbHelper();
            SqlCommand cmd = new SqlCommand();

            string sSQL = "";
            sSQL += " SELECT CONTENTDESC ";
            sSQL += " FROM TBLCONTENT C, TBLCONTENT_L CL ";
            sSQL += " WHERE 1=1 ";
            sSQL += " AND C.CONTENTID = CL.CONTENTID ";
            sSQL += " AND C.UNIQUECODE = 'SUPPORT'  ";
            sSQL += " AND CL.LANGCODE = @LANGCODE ";

            cmd.CommandText = sSQL;
            cmd.Parameters.Add("@LANGCODE", SqlDbType.NVarChar).Value = Session["LANGCODE"].ToString();
            DataTable dt = dsrv.GetDataTable(cmd, "TBL");

            if (dt.Rows.Count > 0)
            {
                ContentRight.InnerHtml = dt.Rows[0][0].ToString();
            }

        }
    }
}
